package com.system.transfer.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;
import com.system.transfer.entity.Transfer;
@org.springframework.stereotype.Repository
public interface TransferRepository extends PagingAndSortingRepository<Transfer, Long>,JpaSpecificationExecutor<Transfer>{
   @Query("select t from Transfer t join t.employee e where e.empId=:empId")
	public List<Transfer> findTransferByEmployee(@Param("empId")Long empId);
}
